Column

A column can be a source, target, or both in a mapping specification. It can also be used for transformations, such as business rules and lookups in a mapping project. The impact analysis on a column helps you identify these impacts of the column on mapping projects.

To perform impact analysis on columns, follow these steps:

  1. Go to Application Menu > Data Catalog > Metadata Manager > Explore.
  2. In the System Catalogue pane, click a column.
  3. Click the Impact Analysis tab.

    4. By default, the Direct Impact tab opens. It displays the impact of the column as source and target.

    To view the indirect impact, click the Indirect tab.

    It displays the upstream and downstream impact of the column.

    To view other impacts, click the Other Impacts tab.

    It displays the impact of the column on:

    • Business rules
    • Source extract SQL
    • Lookups